Pandas Profiling Report: Minutely Data

Dataset statistics

Number of variables	12
Number of observations	19744
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.8 MiB
Average record size in memory	96.0 B

Variable types

NUM	11
DATE	1

Reproduction

Analysis started	2020-06-25 19:23:30.957830
Analysis finished	2020-06-25 19:23:48.420456
Duration	17.46 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`PM2.5` is highly correlated with `PM1` and 1 other fields	High correlation
`PM1` is highly correlated with `PM2.5` and 1 other fields	High correlation
`PM10` is highly correlated with `PM1` and 1 other fields	High correlation
`VOC` is highly skewed (γ1 = 61.33924397)	Skewed
`Time` has unique values	Unique
`H2S` has 19045 (96.5%) zeros	Zeros

Time
Date

UNIQUE

Distinct count	19744
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	154.4 KiB

Minimum	2020-05-26 08:51:45
Maximum	2020-06-09 08:50:02

Histogram

Histogram

Ozone
Real number (ℝ_≥0)

Distinct count	67
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.3467899108589952
Minimum	0.01
Maximum	0.81
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.18
Q1	0.2
median	0.35
Q3	0.44
95-th percentile	0.6
Maximum	0.81
Range	0.8
Interquartile range (IQR)	0.24

Descriptive statistics

Standard deviation	0.1373274672
Coefficient of variation (CV)	0.3959961431
Kurtosis	-0.7381340729
Mean	0.3467899109
Median Absolute Deviation (MAD)	0.12
Skewness	0.4113296776
Sum	6847.02
Variance	0.01885883323

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.18	1985	10.1%
0.19	1587	8.0%
0.2	1279	6.5%
0.41	707	3.6%
0.34	678	3.4%
0.21	629	3.2%
0.43	584	3.0%
0.4	577	2.9%
0.33	569	2.9%
0.35	551	2.8%
0.42	543	2.8%
0.36	492	2.5%
0.44	482	2.4%
0.17	467	2.4%
0.39	442	2.2%
0.47	436	2.2%
0.45	435	2.2%
0.26	405	2.1%
0.46	400	2.0%
0.27	376	1.9%
0.38	367	1.9%
0.37	364	1.8%
0.32	364	1.8%
0.48	342	1.7%
0.49	341	1.7%
Other values (42)	4342	22.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.12	1	< 0.1%
0.13	1	< 0.1%
0.15	1	< 0.1%
0.16	6	< 0.1%
0.17	467	2.4%
0.18	1985	10.1%
0.19	1587	8.0%
0.2	1279	6.5%
0.21	629	3.2%

Value	Count	Frequency (%)
0.81	1	< 0.1%
0.8	1	< 0.1%
0.76	1	< 0.1%
0.75	3	< 0.1%
0.74	14	0.1%
0.73	4	< 0.1%
0.72	12	0.1%
0.71	21	0.1%
0.7	27	0.1%
0.69	33	0.2%

H2S
Real number (ℝ_≥0)

ZEROS

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.527957860615885e-05
Minimum	0.0
Maximum	0.006
Zeros	19045
Zeros (%)	96.5%
Memory size	154.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	0.006
Range	0.006
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.0002551719049
Coefficient of variation (CV)	5.635474374
Kurtosis	60.31697876
Mean	4.527957861e-05
Median Absolute Deviation (MAD)	0
Skewness	6.797485106
Sum	0.894
Variance	6.511270104e-08

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	19045	96.5%
0.001	515	2.6%
0.002	179	0.9%
0.003	2	< 0.1%
0.005	1	< 0.1%
0.006	1	< 0.1%
0.004	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	19045	96.5%
0.001	515	2.6%
0.002	179	0.9%
0.003	2	< 0.1%
0.004	1	< 0.1%
0.005	1	< 0.1%
0.006	1	< 0.1%

Value	Count	Frequency (%)
0.006	1	< 0.1%
0.005	1	< 0.1%
0.004	1	< 0.1%
0.003	2	< 0.1%
0.002	179	0.9%
0.001	515	2.6%
0	19045	96.5%

VOC
Real number (ℝ_≥0)

SKEWED

Distinct count	664
Unique (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1809903768233387
Minimum	0.031
Maximum	71.636
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	0.031
5-th percentile	0.081
Q1	0.13
median	0.145
Q3	0.171
95-th percentile	0.298
Maximum	71.636
Range	71.605
Interquartile range (IQR)	0.041

Descriptive statistics

Standard deviation	0.8302206152
Coefficient of variation (CV)	4.587098109
Kurtosis	4390.570823
Mean	0.1809903768
Median Absolute Deviation (MAD)	0.021
Skewness	61.33924397
Sum	3573.474
Variance	0.6892662699

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0.13	430	2.2%
0.131	429	2.2%
0.132	387	2.0%
0.133	385	1.9%
0.143	379	1.9%
0.144	357	1.8%
0.142	331	1.7%
0.141	327	1.7%
0.129	325	1.6%
0.134	318	1.6%
0.14	314	1.6%
0.172	303	1.5%
0.171	296	1.5%
0.139	294	1.5%
0.169	292	1.5%
0.145	289	1.5%
0.136	285	1.4%
0.17	276	1.4%
0.128	270	1.4%
0.135	269	1.4%
0.127	262	1.3%
0.173	261	1.3%
0.138	258	1.3%
0.168	252	1.3%
0.167	241	1.2%
Other values (639)	11914	60.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.031	1	< 0.1%
0.057	1	< 0.1%
0.065	4	< 0.1%
0.066	7	< 0.1%
0.067	13	0.1%
0.068	21	0.1%
0.069	36	0.2%
0.07	40	0.2%
0.071	43	0.2%
0.072	54	0.3%

Value	Count	Frequency (%)
71.636	1	< 0.1%
58.695	1	< 0.1%
29.578	1	< 0.1%
27.78	1	< 0.1%
27.767	1	< 0.1%
26.843	1	< 0.1%
26.594	1	< 0.1%
23.394	1	< 0.1%
21.702	1	< 0.1%
6.944	1	< 0.1%

CO2
Real number (ℝ_≥0)

Distinct count	500
Unique (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	383.13107779578604
Minimum	270
Maximum	827
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	270
5-th percentile	325
Q1	338
median	354
Q3	387
95-th percentile	601
Maximum	827
Range	557
Interquartile range (IQR)	49

Descriptive statistics

Standard deviation	85.37199061
Coefficient of variation (CV)	0.2228271095
Kurtosis	7.535974106
Mean	383.1310778
Median Absolute Deviation (MAD)	21
Skewness	2.731982615
Sum	7564540
Variance	7288.37678

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
338	403	2.0%
333	395	2.0%
341	395	2.0%
334	392	2.0%
335	381	1.9%
340	372	1.9%
336	361	1.8%
331	354	1.8%
337	354	1.8%
339	349	1.8%
342	338	1.7%
332	337	1.7%
346	317	1.6%
329	309	1.6%
347	305	1.5%
343	302	1.5%
330	301	1.5%
344	297	1.5%
345	293	1.5%
349	289	1.5%
351	276	1.4%
350	272	1.4%
352	263	1.3%
328	262	1.3%
348	252	1.3%
Other values (475)	11575	58.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
270	1	< 0.1%
281	1	< 0.1%
292	1	< 0.1%
294	2	< 0.1%
295	1	< 0.1%
296	3	< 0.1%
297	5	< 0.1%
298	9	< 0.1%
299	15	0.1%
300	12	0.1%

Value	Count	Frequency (%)
827	1	< 0.1%
813	1	< 0.1%
812	1	< 0.1%
796	1	< 0.1%
791	1	< 0.1%
789	2	< 0.1%
787	1	< 0.1%
786	4	< 0.1%
785	3	< 0.1%
784	5	< 0.1%

PM1
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	8713
Unique (%)	44.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.125950617909238
Minimum	0.409
Maximum	37.19
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	0.409
5-th percentile	1.61115
Q1	2.668
median	4.046
Q3	6.94275
95-th percentile	11.32585
Maximum	37.19
Range	36.781
Interquartile range (IQR)	4.27475

Descriptive statistics

Standard deviation	3.369891596
Coefficient of variation (CV)	0.6574178816
Kurtosis	4.854768121
Mean	5.125950618
Median Absolute Deviation (MAD)	1.733
Skewness	1.6655445
Sum	101206.769
Variance	11.35616937

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2.412	12	0.1%
2.703	11	0.1%
2.956	11	0.1%
2.693	11	0.1%
2.854	10	0.1%
2.099	10	0.1%
3.71	10	0.1%
3.592	10	0.1%
2.892	10	0.1%
2.618	10	0.1%
2.592	10	0.1%
2.393	10	0.1%
2.669	10	0.1%
2.843	10	0.1%
2.454	10	0.1%
2.919	10	0.1%
4.105	9	< 0.1%
2.584	9	< 0.1%
2.659	9	< 0.1%
3.147	9	< 0.1%
3.011	9	< 0.1%
2.878	9	< 0.1%
2.299	9	< 0.1%
2.518	9	< 0.1%
2.98	9	< 0.1%
Other values (8688)	19498	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.409	1	< 0.1%
0.451	1	< 0.1%
0.463	1	< 0.1%
0.467	1	< 0.1%
0.469	1	< 0.1%
0.471	1	< 0.1%
0.533	1	< 0.1%
0.542	1	< 0.1%
0.555	1	< 0.1%
0.557	1	< 0.1%

Value	Count	Frequency (%)
37.19	1	< 0.1%
35.463	1	< 0.1%
32.493	1	< 0.1%
30.771	1	< 0.1%
30.362	1	< 0.1%
30.152	1	< 0.1%
29.473	1	< 0.1%
29.455	1	< 0.1%
29.41	1	< 0.1%
28.733	1	< 0.1%

PM2.5
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	9123
Unique (%)	46.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.5936895259319295
Minimum	0.457
Maximum	49.586999999999996
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	0.457
5-th percentile	1.752
Q1	2.9255
median	4.492
Q3	7.516
95-th percentile	12.21085
Maximum	49.587
Range	49.13
Interquartile range (IQR)	4.5905

Descriptive statistics

Standard deviation	3.652229348
Coefficient of variation (CV)	0.6529195679
Kurtosis	6.23457917
Mean	5.593689526
Median Absolute Deviation (MAD)	1.9255
Skewness	1.777352164
Sum	110441.806
Variance	13.33877921

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3.104	12	0.1%
3.312	11	0.1%
2.607	11	0.1%
3.412	10	0.1%
3.582	10	0.1%
4.17	10	0.1%
2.953	10	0.1%
3.299	10	0.1%
3.158	10	0.1%
2.51	9	< 0.1%
2.873	9	< 0.1%
2.883	9	< 0.1%
2.764	9	< 0.1%
2.612	9	< 0.1%
2.438	9	< 0.1%
2.447	9	< 0.1%
2.53	9	< 0.1%
3.07	9	< 0.1%
3.251	9	< 0.1%
2.47	9	< 0.1%
4.181	9	< 0.1%
2.704	9	< 0.1%
2.007	9	< 0.1%
4.605	9	< 0.1%
2.762	9	< 0.1%
Other values (9098)	19506	98.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.457	1	< 0.1%
0.488	1	< 0.1%
0.501	1	< 0.1%
0.502	1	< 0.1%
0.513	1	< 0.1%
0.524	1	< 0.1%
0.586	1	< 0.1%
0.589	1	< 0.1%
0.598	1	< 0.1%
0.611	1	< 0.1%

Value	Count	Frequency (%)
49.587	1	< 0.1%
39.995	1	< 0.1%
35.666	1	< 0.1%
34.573	1	< 0.1%
34.15	1	< 0.1%
33.958	1	< 0.1%
33.05	1	< 0.1%
32.893	1	< 0.1%
32.312	1	< 0.1%
31.824	1	< 0.1%

PM10
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	9276
Unique (%)	47.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.755112692463533
Minimum	0.481
Maximum	61.983
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	0.481
5-th percentile	1.789
Q1	3.037
median	4.6795
Q3	7.633
95-th percentile	12.47085
Maximum	61.983
Range	61.502
Interquartile range (IQR)	4.596

Descriptive statistics

Standard deviation	3.753693567
Coefficient of variation (CV)	0.6522363276
Kurtosis	8.516702628
Mean	5.755112692
Median Absolute Deviation (MAD)	1.9955
Skewness	1.940136241
Sum	113628.945
Variance	14.0902154

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3.133	11	0.1%
3.544	10	0.1%
1.959	10	0.1%
2.982	10	0.1%
3.09	10	0.1%
1.842	9	< 0.1%
2.762	9	< 0.1%
4.413	9	< 0.1%
2.918	9	< 0.1%
3.341	9	< 0.1%
2.771	9	< 0.1%
4.333	9	< 0.1%
2.842	9	< 0.1%
4.022	9	< 0.1%
2.989	9	< 0.1%
2.59	8	< 0.1%
2.84	8	< 0.1%
3.915	8	< 0.1%
5.104	8	< 0.1%
4.794	8	< 0.1%
3.056	8	< 0.1%
2.499	8	< 0.1%
3.719	8	< 0.1%
4.628	8	< 0.1%
2.439	8	< 0.1%
Other values (9251)	19523	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.481	1	< 0.1%
0.5	1	< 0.1%
0.505	1	< 0.1%
0.51	1	< 0.1%
0.536	1	< 0.1%
0.549	1	< 0.1%
0.589	1	< 0.1%
0.609	1	< 0.1%
0.621	1	< 0.1%
0.628	1	< 0.1%

Value	Count	Frequency (%)
61.983	1	< 0.1%
42.479	1	< 0.1%
37.306	1	< 0.1%
37.066	1	< 0.1%
36.934	1	< 0.1%
35.817	1	< 0.1%
34.879	1	< 0.1%
34.725	1	< 0.1%
34.614	1	< 0.1%
34.185	1	< 0.1%

Temp_int
Real number (ℝ_≥0)

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	25.777755267423014
Minimum	23
Maximum	31
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	23
5-th percentile	24
Q1	26
median	26
Q3	26
95-th percentile	26
Maximum	31
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8476271994
Coefficient of variation (CV)	0.03288211835
Kurtosis	4.353994929
Mean	25.77775527
Median Absolute Deviation (MAD)	0
Skewness	-0.4007404378
Sum	508956
Variance	0.7184718692

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
26	16012	81.1%
24	2790	14.1%
27	421	2.1%
28	266	1.3%
23	68	0.3%
29	63	0.3%
30	60	0.3%
25	51	0.3%
31	13	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
23	68	0.3%
24	2790	14.1%
25	51	0.3%
26	16012	81.1%
27	421	2.1%
28	266	1.3%
29	63	0.3%
30	60	0.3%
31	13	0.1%

Value	Count	Frequency (%)
31	13	0.1%
30	60	0.3%
29	63	0.3%
28	266	1.3%
27	421	2.1%
26	16012	81.1%
25	51	0.3%
24	2790	14.1%
23	68	0.3%

Humidity_int
Real number (ℝ_≥0)

Distinct count	55
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50.43932333873582
Minimum	0
Maximum	82
Zeros	4
Zeros (%)	< 0.1%
Memory size	154.4 KiB

Quantile statistics

Minimum	0
5-th percentile	32
Q1	40
median	49
Q3	59
95-th percentile	74
Maximum	82
Range	82
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	12.92818582
Coefficient of variation (CV)	0.2563116427
Kurtosis	-0.7239317546
Mean	50.43932334
Median Absolute Deviation (MAD)	9
Skewness	0.364886994
Sum	995874
Variance	167.1379886

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
45	837	4.2%
48	791	4.0%
55	720	3.6%
56	704	3.6%
36	697	3.5%
46	678	3.4%
47	675	3.4%
35	638	3.2%
49	605	3.1%
44	555	2.8%
50	555	2.8%
34	522	2.6%
37	511	2.6%
60	509	2.6%
33	508	2.6%
54	494	2.5%
51	483	2.4%
43	475	2.4%
74	445	2.3%
73	435	2.2%
58	417	2.1%
32	410	2.1%
59	405	2.1%
53	378	1.9%
30	377	1.9%
Other values (30)	5920	30.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4	< 0.1%
29	129	0.7%
30	377	1.9%
31	273	1.4%
32	410	2.1%
33	508	2.6%
34	522	2.6%
35	638	3.2%
36	697	3.5%
37	511	2.6%

Value	Count	Frequency (%)
82	1	< 0.1%
81	1	< 0.1%
80	8	< 0.1%
79	35	0.2%
78	80	0.4%
77	147	0.7%
76	237	1.2%
75	304	1.5%
74	445	2.3%
73	435	2.2%

Temp_ext
Real number (ℝ_≥0)

Distinct count	23
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.423369124797407
Minimum	14
Maximum	36
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	14
5-th percentile	17
Q1	21
median	24
Q3	25
95-th percentile	31
Maximum	36
Range	22
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	4.060239167
Coefficient of variation (CV)	0.1733413816
Kurtosis	0.3053075611
Mean	23.42336912
Median Absolute Deviation (MAD)	2
Skewness	0.2384510332
Sum	462471
Variance	16.48554209

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
24	3378	17.1%
25	2953	15.0%
23	2270	11.5%
21	1438	7.3%
19	1282	6.5%
22	1073	5.4%
20	1023	5.2%
28	837	4.2%
18	798	4.0%
29	596	3.0%
27	577	2.9%
26	550	2.8%
17	508	2.6%
30	468	2.4%
15	465	2.4%
31	309	1.6%
16	295	1.5%
32	238	1.2%
33	227	1.1%
34	185	0.9%
14	153	0.8%
35	66	0.3%
36	55	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14	153	0.8%
15	465	2.4%
16	295	1.5%
17	508	2.6%
18	798	4.0%
19	1282	6.5%
20	1023	5.2%
21	1438	7.3%
22	1073	5.4%
23	2270	11.5%

Value	Count	Frequency (%)
36	55	0.3%
35	66	0.3%
34	185	0.9%
33	227	1.1%
32	238	1.2%
31	309	1.6%
30	468	2.4%
29	596	3.0%
28	837	4.2%
27	577	2.9%

Humidity_ext
Real number (ℝ_≥0)

Distinct count	69
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	48.644094408427875
Minimum	18
Maximum	86
Zeros	0
Zeros (%)	0.0%
Memory size	154.4 KiB

Quantile statistics

Minimum	18
5-th percentile	27
Q1	38
median	49
Q3	57
95-th percentile	80
Maximum	86
Range	68
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	14.54870076
Coefficient of variation (CV)	0.2990846256
Kurtosis	-0.04146133123
Mean	48.64409441
Median Absolute Deviation (MAD)	10
Skewness	0.4078076023
Sum	960429
Variance	211.6646939

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
38	976	4.9%
50	799	4.0%
52	764	3.9%
51	755	3.8%
49	702	3.6%
48	627	3.2%
46	627	3.2%
54	615	3.1%
53	610	3.1%
57	574	2.9%
31	545	2.8%
29	518	2.6%
37	509	2.6%
55	503	2.5%
32	494	2.5%
56	487	2.5%
45	455	2.3%
47	416	2.1%
40	385	1.9%
60	368	1.9%
58	335	1.7%
59	334	1.7%
61	333	1.7%
33	297	1.5%
30	294	1.5%
Other values (44)	6422	32.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18	1	< 0.1%
19	49	0.2%
20	162	0.8%
21	74	0.4%
22	57	0.3%
23	135	0.7%
24	196	1.0%
25	132	0.7%
26	123	0.6%
27	177	0.9%

Value	Count	Frequency (%)
86	16	0.1%
85	189	1.0%
84	264	1.3%
83	153	0.8%
82	128	0.6%
81	159	0.8%
80	110	0.6%
79	85	0.4%
78	51	0.3%
77	43	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	Time	Ozone	H2S	VOC	CO2	PM1	PM2.5	PM10	Temp_int	Humidity_int	Temp_ext	Humidity_ext
0	2020-05-26 08:51:45	0.21	0.000	0.266	467	18.270	19.519	19.759	24	46	23	48
1	2020-05-26 08:52:44	0.22	0.001	0.268	467	14.326	15.149	15.149	24	46	23	48
2	2020-05-26 08:53:44	0.22	0.001	0.269	468	10.830	11.453	11.453	24	46	23	48
3	2020-05-26 08:54:44	0.21	0.001	0.270	474	11.914	12.798	13.038	24	46	23	48
4	2020-05-26 08:55:43	0.21	0.001	0.269	478	13.232	13.992	13.992	24	46	23	48
5	2020-05-26 09:01:40	0.20	0.003	29.578	345	1.835	1.940	1.940	24	46	24	48
6	2020-05-26 09:01:54	0.22	0.001	0.257	497	5.910	6.249	6.249	24	46	23	48
7	2020-05-26 09:02:54	0.21	0.001	0.260	498	6.191	6.747	6.989	24	46	23	48
8	2020-05-26 09:03:53	0.21	0.001	0.257	497	5.257	5.760	6.002	24	46	23	48
9	2020-05-26 09:04:53	0.21	0.001	0.253	490	5.006	5.294	5.294	24	46	23	48

Last rows

	Time	Ozone	VOC	CO2	PM1	PM2.5	PM10	Temp_int	Humidity_int	Temp_ext	Humidity_ext
19734	2020-06-09 08:38:14	0.40	0.183	382	5.803	6.621	7.153	26	39	23	46
19735	2020-06-09 08:39:13	0.38	0.185	386	4.904	5.404	5.616	26	39	23	46
19736	2020-06-09 08:40:13	0.39	0.187	389	5.228	5.754	5.973	26	39	23	46
19737	2020-06-09 08:41:12	0.37	0.185	385	5.257	5.833	6.099	26	39	23	46
19738	2020-06-09 08:42:11	0.40	0.186	382	5.296	5.877	6.145	26	39	23	46
19739	2020-06-09 08:43:11	0.39	0.188	382	5.949	6.611	6.922	26	39	23	46
19740	2020-06-09 08:44:10	0.36	0.190	380	6.446	7.245	7.661	26	39	23	45
19741	2020-06-09 08:48:25	0.40	0.180	381	4.432	5.080	5.462	26	39	23	43
19742	2020-06-09 08:49:03	0.43	0.179	388	6.207	7.307	8.094	26	39	23	44
19743	2020-06-09 08:50:02	0.39	0.178	381	6.368	7.282	7.815	26	39	23	44

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows